Release 10.1A: OpenEdge Development:
Progress 4GL Reference

DBTASKID function

Returns an INTEGER that uniquely identifies a database’s transaction.

Syntax

DBTASKID ( integer-expression | logical-name | alias )

integer-expression

The sequence number of a database the OpenEdge session is connected to. For example, DBTASKID(1) returns information on the first database the OpenEdge session is connected to, DBTASKID(2) returns information on the second database the OpenEdge session is connected to, etc. If you specify a sequence number that does not correspond to a database the OpenEdge session is connected to, the DBTASKID function returns the Unknown value (?).

logical-name or alias

A character expression that evaluates to the logical name or alias of a database that is connected to the current OpenEdge session. If the character expression does not evaluate to the logical name or alias of a connected database, DBTASKID returns the Unknown value (?).

Note: You must enclose all character strings in quotes.

Notes

If the application is not in a transaction, DBTASKID returns the Unknown value (?).
If the client is connected to two databases and both databases participate in the transaction, DBTASKID does not necessarily return the same value for each database. The value DBTASKID returns for a database is for that database only.
DBTASKID supports Version 8 and Version 9 Progress databases only. DBTASKID returns the Unknown value (?) for DataServers, Version 7 Progress databases, and the temporary table database.
DBTASKID is designed for database replication. When you create a log record for a transaction, you can call DBTASKID and store the transaction ID. When you load the transaction, you can group log records by transaction ID. For more information on database replication, see OpenEdge Data Management: Database Administration , and the reference entry for the RAW-TRANSFER statement in this book.

See also

DBCODEPAGE function, DBCOLLATION function, DBTYPE function, DBVERSION function, LDBNAME function